SongAlbumRecording
Star Dust In the Still of the Night 245
   "Moonglow 479
   "Benny Goodman, The Small Groups 680
   "Jazz at Oberlin 734
   "Legendary Hoagy Carmichael, The 741
   "   "754
   "Dancing in the Dark 1031
   "Yes Indeed! 1499
   "Best of the Big Bands, The 1820
   "Sanitone Drycleaner Record 1875
   "Star Dust 1994
   "Those Swingin' Days of the Big Bands 2380
   "Misty Keely 2440
   "25 2541
   "Giants of Jazz - Benny Carter 3154
   "Giants of Jazz - Louis Armstrong 3303
   "Popular Recordings, The (1938-1942) 4456
   "Tribute 4498
   "Swing Era, Music of 1940-1941 5266
   "Big Band Jazz 5480
   "Benny Goodman Sextet with Charlie Christian 6264
   "Jazz in the Charts (1930) 6848
   "Star Dust Memories 6880
   "Moody's Mood 7186
   "Charlie Barnet 7550
   "Rare Radio Recordings 1953, 1954 7613
   "'S Wonderful 8434
   "Dream Awhile 9173
   "Charlie Christian 9628
   "   "9630
   "Among My Souvenirs 9925
   "Satin Affair 10137
   "Best of Artie Shaw, The 10221
   "'S Wonderful (1949-1950 Recordings) 10741
   "Excitement in Stereo Sound 11438
   "Reunion with Chet Baker 11558
   "Two of a Mind 11564

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Star Dust"